UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cNJfsRsZpgwsnzT4kYVOj8vFlIkfm20eXRhUOO7Ee18='
WHERE
key_id = 'fcf18ae159a3eefa4f9138b762c8636a595e7bc9ad9e1b132de84a7b96991743'
AND (
token = 'cNJfsRsZpgwsnzT4kYVOj8vFlIkfm20eXRhUOO7Ee18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)