UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XVQRoc0HmfLo21OzRo3KSfctcLD1F90pfuc8P3ggAHM='
WHERE
key_id = '8faf8b74609154c65479f49612ca5da3a0a947ad41da360e2d5292f48226982e'
AND (
token = 'XVQRoc0HmfLo21OzRo3KSfctcLD1F90pfuc8P3ggAHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)