UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N1jt+J+JV7RaGyBymxUY9oitAAyILpZ2VNLUDJKR9JE='
WHERE
key_id = '12a714d462aa5eb78b05ae2bccb9d0e2a4fb42518895ea36bd9e5c86dcb75ad2'
AND (
token = 'N1jt+J+JV7RaGyBymxUY9oitAAyILpZ2VNLUDJKR9JE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)