UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3GDP2/OT3t6NfLDM/ZMuBQROpeK+qOFnPtM2I2OCbZw='
WHERE
key_id = 'a858d9a17d987437364a3e80023a9f12c35c81d9b99eba2159755602522539d7'
AND (
token = '3GDP2/OT3t6NfLDM/ZMuBQROpeK+qOFnPtM2I2OCbZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)