UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jeEEOUD5aM+JyxVlonxd8jQC/rgB6Wsksea5xtpXXYE='
WHERE
key_id = '196d825fa9b02b3abf770f762f7adfb67cc6266b51121145c65165a3087b287d'
AND (
token = 'jeEEOUD5aM+JyxVlonxd8jQC/rgB6Wsksea5xtpXXYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)