UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8iu5RKJpH8Tm2ovYqxYM8zV/2n+73imZ3AAL6xfDNJk=' 
WHERE 
  key_id = 'f8fa2e9fac4c6d0cd2f84f7e39d42b4024ad98ba19a4d501376fbb302340491b' 
  AND (
    token = '8iu5RKJpH8Tm2ovYqxYM8zV/2n+73imZ3AAL6xfDNJk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025