UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vWB3BYgcbAmR1bg6gv06JxjUFE7yjnWvzXAw9t/ek8I='
WHERE
key_id = '0c9cb0511986017f58aa79e39e31839143707d65d721f6aa191ec51b82525301'
AND (
token = 'vWB3BYgcbAmR1bg6gv06JxjUFE7yjnWvzXAw9t/ek8I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)