UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'weDHjho+fezPwQCMevGxjnht1DpmMexldhwvkdaSaws='
WHERE
key_id = '1fcd476d7a0e73f0494774e5d6710369b3f5a4f5985f3438a3b8915310af270e'
AND (
token = 'weDHjho+fezPwQCMevGxjnht1DpmMexldhwvkdaSaws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)