UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Wo2Eh1ndcIwL2w8GbJWtS93HzUz8eAh3eNDjKmA/C5U=' 
WHERE 
  key_id = '897c611f7eaf9572bd6b4444df87a21993fc25f0f4dea6808274166af146cdfc' 
  AND (
    token = 'Wo2Eh1ndcIwL2w8GbJWtS93HzUz8eAh3eNDjKmA/C5U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022