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