UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RmPA8lRW3vmuddu1eLq7JMm8fjG89GP9UgoXwEl+yWU='
WHERE
key_id = '6dca013e2f2308a112b37c53041e316695264a51fd1b83d3d8d1e8df94fc9f45'
AND (
token = 'RmPA8lRW3vmuddu1eLq7JMm8fjG89GP9UgoXwEl+yWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)