UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qiV7hilo7gQBKoIPvpzFBui4oPPXYoTuRSJruqWWwAU='
WHERE
key_id = '64280c6c62cfc0c95ae33a3e7596fa3157abdb1aa99a1dff73a920ba108a9ec8'
AND (
token = 'qiV7hilo7gQBKoIPvpzFBui4oPPXYoTuRSJruqWWwAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)