UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l7kaK3oWtqSx+lWlsj5Psu23RYrWh+OUKMuGC8v3o68='
WHERE
key_id = 'bee4ef4aae9d7b60da9dd8026866b757ef506e23ffe9614795bf8ce7bc2e268e'
AND (
token = 'l7kaK3oWtqSx+lWlsj5Psu23RYrWh+OUKMuGC8v3o68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)