UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2CxLxTnw7MGiyy00NDvRenf/ThxlQcn8wl8T1MSbbnY=' 
WHERE 
  key_id = '47b1682b3522c1c9aa37da0d57cff4b2b548689e28a34579cadf28255fc7f829' 
  AND (
    token = '2CxLxTnw7MGiyy00NDvRenf/ThxlQcn8wl8T1MSbbnY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029