UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nxy0yFTv51VxiAVdqP9ucPTdn/M7thd6gq575+qbYZg='
WHERE
key_id = '23a4c82b6c8050cdc306d3624329c4e500e720c2301d70e70a76466b3e98591d'
AND (
token = 'nxy0yFTv51VxiAVdqP9ucPTdn/M7thd6gq575+qbYZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)