UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'URO8NSsW5nvtZP844EVjrUhh6n0XlJ46/LWGJ3O6yZQ='
WHERE
key_id = 'df872e9b89739943c720c8a27a39e3c7e94d4441fe2ccb74538b6ab8ab7020b5'
AND (
token = 'URO8NSsW5nvtZP844EVjrUhh6n0XlJ46/LWGJ3O6yZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)