UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Ur5+x/ZQ+PYaR6Qqge827Iv+/K4UZKEWYIqZyd1jmLs=' 
WHERE 
  key_id = 'e78c11925340f79095c77f8041093ce21af8406677223cba5f17155d17273558' 
  AND (
    token = 'Ur5+x/ZQ+PYaR6Qqge827Iv+/K4UZKEWYIqZyd1jmLs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036