UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PCv9P7qIevrSQaf506mQpGKYJAlCLUGz1hRFSLeiDQ8='
WHERE
key_id = '564b4d69b9de9f54a96340ca8f542567a5ebdfbd246ee1dc7665c90d53f3deb2'
AND (
token = 'PCv9P7qIevrSQaf506mQpGKYJAlCLUGz1hRFSLeiDQ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)