UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eF19FcnZ1V2JJZKxaJHphM1YASPlGUSYBM1oE9a1tbU='
WHERE
key_id = '4138dca7b934dbb75a87207093b59860ccd42776eab12a24840f760c7c6cbd50'
AND (
token = 'eF19FcnZ1V2JJZKxaJHphM1YASPlGUSYBM1oE9a1tbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)