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