UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lMSscg5B1OgYRn7R8oHvoPLoS0VpTYTm8UVXyN8dCfA='
WHERE
key_id = 'b911e57a95173e4f47150fd90735617f5a8d222169a46e5e3cfe954532b97e55'
AND (
token = 'lMSscg5B1OgYRn7R8oHvoPLoS0VpTYTm8UVXyN8dCfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)