UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HkEFxHXO1R7MHuAUmUZhYPUPlm9T8aNbp7H1zc4De0g='
WHERE
key_id = '3aaa40d12ba06f6fa050841e54a288009ace1a2b14050f4d1aef7098a32d59b1'
AND (
token = 'HkEFxHXO1R7MHuAUmUZhYPUPlm9T8aNbp7H1zc4De0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)