UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sCXAqzlxrk3RSDy8A7haI0dp0B6SvK8OokZZXM4s7sI='
WHERE
key_id = '03a2f14258077c2d7f5e0090a8a0217feff88d6f39fdc384035b2b2d59767e01'
AND (
token = 'sCXAqzlxrk3RSDy8A7haI0dp0B6SvK8OokZZXM4s7sI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)