UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'h4J/rFQ0Ykn8sQIP7m1d0XZq4QFJqKZzxU4UniscXrI=' 
WHERE 
  key_id = '8335799c7efd74a1b4c4924d0f3fe5888e16e09f5fcf6ed98a4cffad27342980' 
  AND (
    token = 'h4J/rFQ0Ykn8sQIP7m1d0XZq4QFJqKZzxU4UniscXrI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020