UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xtmodqNrF5486uJazOTvYmcBcX2ZA4dZoZebm+66IGE='
WHERE
key_id = '49315ad1e1102d61c81d0b8322988b048f815896e8743fa29f64447cc5f8b3a6'
AND (
token = 'xtmodqNrF5486uJazOTvYmcBcX2ZA4dZoZebm+66IGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)