UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JMCoTQiyT8Uir88q0ma6cwV1g/7q1UHX7pqY5+X2ASo=' 
WHERE 
  key_id = '9f90532a11fdb69b3782ba2ebfabae1fd98bd98052c0f98e5f1f72f04f0fa20a' 
  AND (
    token = 'JMCoTQiyT8Uir88q0ma6cwV1g/7q1UHX7pqY5+X2ASo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032