UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OQOUb5vwrUSeBu/CiyvSKM1IuM2y7wJZIRJjx6EvrpA='
WHERE
key_id = 'a024e83f2ae99c428912f3aee104eef6083171317e2d8db5b7df5e70e120fd31'
AND (
token = 'OQOUb5vwrUSeBu/CiyvSKM1IuM2y7wJZIRJjx6EvrpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)