UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yri2wNP0GSsaMrqgaVJIpKEvb/UPupiuhMLelzBU/D8='
WHERE
key_id = 'c527118f78e0a0bbf6824cf8825a1895b591964beff8f13f1970a3d084e8c037'
AND (
token = 'Yri2wNP0GSsaMrqgaVJIpKEvb/UPupiuhMLelzBU/D8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)