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