UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gw5dKVeF0o2WCEwvHWJzF55Z8g5a2uLuwP2VdiEYc2Q='
WHERE
key_id = '78bd7b05d5dc241f630020b89fa28e04f8e0bb880f4d3e1ec37ea57ff33dcf84'
AND (
token = 'gw5dKVeF0o2WCEwvHWJzF55Z8g5a2uLuwP2VdiEYc2Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)