UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/JCalYRA3LOGJA4ZpjKu8p/KoK4q0EiO6Szx/kAYJZA=' 
WHERE 
  key_id = '351758085d4a2a935b93ba0aebb8d080e37a29112c11e625d0fa87e0b7003ad3' 
  AND (
    token = '/JCalYRA3LOGJA4ZpjKu8p/KoK4q0EiO6Szx/kAYJZA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047